How to search Changed Objects within in a Item Interval

Dear All,

I am working on DOORS integration. I want to get the objects for a project which are modified for a certial time period.

Please help me.


montapas - Tue Mar 25 02:44:53 EDT 2014

Re: How to search Changed Objects within in a Item Interval
MyDeveloerWorks - Tue Mar 25 03:44:59 EDT 2014

Hello,

 

What type of tool do you want to integrate with ? If its a SCM/VC tool then which one?

There is another forum on DOORS integrations, I suggest you look there if there are any previous solutions regarding the tool you want to integrate with.

https://www.ibm.com/developerworks/community/forums/html/forum?id=11111111-0000-0000-0000-000000001504

BTW, I have a related topic open on which attributes were modified over a certain time period, specifically "Test Run Attributes", but this deals with an internal feature of DOORS. If you watch how that topic develops (opened yesterday),  you might get some hints

HTH

Colm

Re: How to search Changed Objects within in a Item Interval
montapas - Tue Mar 25 05:35:50 EDT 2014

MyDeveloerWorks - Tue Mar 25 03:44:59 EDT 2014

Hello,

 

What type of tool do you want to integrate with ? If its a SCM/VC tool then which one?

There is another forum on DOORS integrations, I suggest you look there if there are any previous solutions regarding the tool you want to integrate with.

https://www.ibm.com/developerworks/community/forums/html/forum?id=11111111-0000-0000-0000-000000001504

BTW, I have a related topic open on which attributes were modified over a certain time period, specifically "Test Run Attributes", but this deals with an internal feature of DOORS. If you watch how that topic develops (opened yesterday),  you might get some hints

HTH

Colm

Thank you for your response. I want to integrate with my in house tool. could you give me some idea how to solve this problem?

Re: How to search Changed Objects within in a Item Interval
MyDeveloerWorks - Wed Mar 26 05:00:02 EDT 2014

montapas - Tue Mar 25 05:35:50 EDT 2014

Thank you for your response. I want to integrate with my in house tool. could you give me some idea how to solve this problem?

You need to read the API manual. It provides the IPC facilities to establish a link with the DOORS tool.

https://publib.boulder.ibm.com/infocenter/rsdp/v1r0m0/topic/com.ibm.help.download.doors.doc/pdf92/doors_api_manual.pdf

Re: How to search Changed Objects within in a Item Interval
llandale - Wed Mar 26 17:01:17 EDT 2014

Don't know about "integration", but you can query the "Last Modified On" attribute of Objects to find out when they changed at all.  You could also query History of Objects looking for modifications to a certain list of attributes, such as "Object Heading" and "Review Notes".  Once you got the relevant modification date of an object you can check to see if it is within which ever Window you care about; within last 7 days, in Februrary, or whatever.

-Louie

Re: How to search Changed Objects within in a Item Interval
MyDeveloerWorks - Thu Mar 27 05:18:38 EDT 2014

llandale - Wed Mar 26 17:01:17 EDT 2014

Don't know about "integration", but you can query the "Last Modified On" attribute of Objects to find out when they changed at all.  You could also query History of Objects looking for modifications to a certain list of attributes, such as "Object Heading" and "Review Notes".  Once you got the relevant modification date of an object you can check to see if it is within which ever Window you care about; within last 7 days, in Februrary, or whatever.

-Louie

Hello Louie,

This follow up is probably related more to my question "Harvesting out Test Run Attributes", so apologies if this deviates from orginal question too much. The "Last Modified On" is an attribute I had not considered  when I wanted to run a query of all Test Runs that occurred between a particular set of dates.  Here is the code I put together. I have some Test Runs that were modified on 7 Feb 2014. But if I put the interval date on 6 Feb, the TR on 7th Feb is not found. I also found it doesnt run for certain dates entered. 

void print(History h,Date d1, Date d2) 
{
    
    clear();
    HistoryType ht = h.type 
    print h.author "\t" h.date "\t" ht "\t" 
    if ( ht == modifyObject) 
    {
                Date d= h.date
                /// Check d is earlier than d1 and later than d2
                if((d<d1)&&(d>=d2))
                { 
        
                        string s= h.attrName
                        if (matches("Test Status",s) )
                        {
                        
                                string stringForm = stringOf(d, userLocale) 
                                print "Test Run Data" "\t"
                                print h.absNo "\t" 
                                print stringForm "\t" 
                                print h.author "\t" 
                                print "\n"
                        }
                }
 
        }
    //print "\n"
} 
History h_global

Date date1 = today
int iDate1= intOf(today)
Date date2 =  dateOf(iDate1-(24*60*60*31))
int iDate2= intOf(date2)

DB TestCaseHistoryDB = create("TestCaseHistory ", styleCentered)

DBE cNameDBE = field(TestCaseHistoryDB, "Test Author", "John Doe", 20, false)
DBE dateLblDBE1 = label(TestCaseHistoryDB, "End Test Interval")
DBE oDateDBE1 = date(TestCaseHistoryDB, 30,null, true)
DBE dateLblDBE2 = label(TestCaseHistoryDB, "Begin Test Interval:")
DBE oDateDBE2 = date(TestCaseHistoryDB, 30,null, true)


void makeTestCaseHistory(DB winDB) {
    string cName = get(cNameDBE)
    Date oDate = get(oDateDBE1)
    Date oDate2 = get(oDateDBE2)

    for h_global in current Module do print(h_global,oDate,oDate2) 


}
apply(TestCaseHistoryDB, "Go", makeTestCaseHistory)
realize(TestCaseHistoryDB)
show(TestCaseHistoryDB)

Re: How to search Changed Objects within in a Item Interval
MyDeveloerWorks - Thu Mar 27 06:30:36 EDT 2014

montapas - Tue Mar 25 05:35:50 EDT 2014

Thank you for your response. I want to integrate with my in house tool. could you give me some idea how to solve this problem?

Hello,

 

I just came across the following link on Tony Gs wesbite, this might be useful if your tool uses XMI.

http://www.smartdxl.com/content/?page_id=275